How to: Print a range with row and column titles each time a worksheet prints.
Solution:
Select 'Page Setup...' from the 'File' menu. Click the 'Sheet' tab. Set the print area and specify the row and column titles that are to appear on each printed page.
1) Open the workbook to print.
2) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
3) Click 'Sheet' tab.
4) Type the references or the defined names of the cells to be printed in the 'Print Area' box.
NOTE: After print areas are defined for the selected sheets, only those areas will be printed.
5) Do one or both of the following:
a) Type the cell references of the rows containing the titles to be printed at the top of each printed page in the 'Rows to Repeat at Top' box.
b) Type the cell references of the columns containing the titles to be printed at the left of each printed page in the 'Columns to Repeat at Left' box.
Specifying the print area and titles
6) (Optional) Select the appropriate options in the 'Print' and the 'Page Order' groups.
7) Do one of the following:
a) Click 'OK' to save the settings without printing.
b) Print the area:
1] Click 'Print...'. (The Print dialog box appears.)
2] (Optional) Select the appropriate printer from the 'Name' drop-down list of the 'Printer' group.
3] Click 'OK'.
